SQL Querying Advanced
In today's competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization's processes and give it a competitive edge. Some data analysis tasks may require that you query multiple tables simultaneously or create complex views of data.
In this course, you will learn advanced querying techniques such as writing nested queries, using JOINs to combine data from multiple tables, summarizing query results, using advanced filtering, and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance, and learn how to work with multiple tasks as a transaction.
6 courses found
-
- Delivery Format: Virtual Learning
- Date 25 January, 2027 | 8:30 AM to 4:30 PM
- Location: Virtual (Eastern Standard Time)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 02 April, 2027 | 8:30 AM to 4:30 PM
- Location: Virtual (Eastern Standard Time)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 04 June, 2027 | 8:30 AM to 4:30 PM
- Location: Virtual (Eastern Standard Time)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 06 August, 2027 | 8:30 AM to 4:30 PM
- Location: Virtual (Eastern Standard Time)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 04 October, 2027 | 8:30 AM to 4:30 PM
- Location: Virtual (Eastern Standard Time)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 10 December, 2027 | 8:30 AM to 4:30 PM
- Location: Virtual (Eastern Standard Time)
- Language: English
Request a date or location for this course
